UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9W+CETIFuvZuNbsnn15Trh78st0QA5JD1wsAw4juyyE='
WHERE
key_id = '504589f0e6e335b3927ee2667a4a5aecbce46616a7532f324d55bf68ce0cc8ad'
AND (
token = '9W+CETIFuvZuNbsnn15Trh78st0QA5JD1wsAw4juyyE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)