UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6SgPEKKA+2cw68mU57p31DWkZpwAH0KhuONAynDsbSY='
WHERE
key_id = '2b0970203c35edd2ed10c7e3fca59ee805bf3b5dd1ed483e4affae3dc5e2b2a7'
AND (
token = '6SgPEKKA+2cw68mU57p31DWkZpwAH0KhuONAynDsbSY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)