UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9UPIv4iZsnlSsuh9wsHi5jPGav85VXHCfmKvv6xkRzo='
WHERE
key_id = '9f9b873f4f17a1ba08f228a3e30cbf69f33b6fb8b5c0ca16a99690a3bf169994'
AND (
token = '9UPIv4iZsnlSsuh9wsHi5jPGav85VXHCfmKvv6xkRzo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)