UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '50fyGCQs6j3+7v4mJjPrIXpfSyjZjh4a3z3diHoVhcA='
WHERE
key_id = '7ef3a199b0144cac6d2a778485ab825b7af1ff5626ff08fce47600ed5e2b4122'
AND (
token = '50fyGCQs6j3+7v4mJjPrIXpfSyjZjh4a3z3diHoVhcA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)