UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p2tZiIVbR3NReI0lvqhru38aLrvGodC5+do3Ilp5wFI='
WHERE
key_id = '8e09feb2c79135467582e53415333ce75db240e4e86100c4baec9d84a53d8600'
AND (
token = 'p2tZiIVbR3NReI0lvqhru38aLrvGodC5+do3Ilp5wFI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)