UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lkkXu+TSc8NH1vAgNRXhIeVnk9AUWC+cgceaft+3Pls='
WHERE
key_id = '6b8ca163583abfad1c383062950de4a09a9512db195a3bc296d5dc695b937458'
AND (
token = 'lkkXu+TSc8NH1vAgNRXhIeVnk9AUWC+cgceaft+3Pls='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)