UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YSrwtD3t5VfcEBiEjm6l/qWV7qXH1ED6ZYlzGuCvS4Q='
WHERE
key_id = '1698d870bea7c5a1fd8885c6813fceda779bf71e9afa7b4ee2f8908a71167857'
AND (
token = 'YSrwtD3t5VfcEBiEjm6l/qWV7qXH1ED6ZYlzGuCvS4Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)