UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P6h20sOAF8wHiWVkX2JOw1DaYinbzUlrQrUYY88AGcY='
WHERE
key_id = '2fac17ef37e3c91ea08045d4ac57277413bf1d627660f65d55faae8ff0d90641'
AND (
token = 'P6h20sOAF8wHiWVkX2JOw1DaYinbzUlrQrUYY88AGcY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)