UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'firaTnkgyZ1wYQL0Km337bj/G27kahCI+m4mYQ3OR0k='
WHERE
key_id = 'caed591fb5b61fb801ee952795f14e79ad4dbe0eaa5e687c43818cd8bc31c0ec'
AND (
token = 'firaTnkgyZ1wYQL0Km337bj/G27kahCI+m4mYQ3OR0k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)