UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KEGHatt1zgOgWyyFLzDiXoinggkty8eM9uzy90BWYT4='
WHERE
key_id = 'be4c5b1bbc1910648220e26f112457f33281a3d48dbb517e454117cfdb4a343f'
AND (
token = 'KEGHatt1zgOgWyyFLzDiXoinggkty8eM9uzy90BWYT4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)