UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DCKKRkPSnlm2lEYNLgh3Os01qvPcI26xAaGiLo1UdNI='
WHERE
key_id = 'b186c4b53f94c5d76f3831a33dfa858756821d058030ba615acc8bb18b3f6cc8'
AND (
token = 'DCKKRkPSnlm2lEYNLgh3Os01qvPcI26xAaGiLo1UdNI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)