UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lOLv9rwiuuIliqHAR0BGuWE1CLkfDPr/S/Zb67Uof98='
WHERE
key_id = 'a954eec0ba5506b7346a1e786e73e0d05dbe2e387b6a0b50d29b72bf0022b0c4'
AND (
token = 'lOLv9rwiuuIliqHAR0BGuWE1CLkfDPr/S/Zb67Uof98='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)