UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZrSzgiDL3tm/sstdZwqo7E7IpD/M9KC9bbGWWhd6tco='
WHERE
key_id = 'a4603374730dcbb835f9129e7477b88636324f2d21c9e7a11afdd352b95f4ff0'
AND (
token = 'ZrSzgiDL3tm/sstdZwqo7E7IpD/M9KC9bbGWWhd6tco='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)