UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aWUzEHda+5lAKMpx602tJO1t3vQdP4D0boBFmBJYChA='
WHERE
key_id = 'fbc0c90178403bf8334b113ed9d8e77f6a8249e2148adc2ab75f2f35fe02ecc5'
AND (
token = 'aWUzEHda+5lAKMpx602tJO1t3vQdP4D0boBFmBJYChA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)