UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mDgP8uJehDmM6iLh4wMketTSUJuzfMjgjcPt0/8g3Qw='
WHERE
key_id = '56caec8621bf4b250d85ea9d2f5932c92de37265640f4412e8f996b5048536a2'
AND (
token = 'mDgP8uJehDmM6iLh4wMketTSUJuzfMjgjcPt0/8g3Qw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)