UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pnXpdOCq6lII+E7vYPJ7cx6uUvDntfYFTAZshEPoPLM='
WHERE
key_id = 'c5a69b8b86adec567e1df85ad2ad630e53643fb99176d2b989c4a95f30e6f6d3'
AND (
token = 'pnXpdOCq6lII+E7vYPJ7cx6uUvDntfYFTAZshEPoPLM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)