UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3epl6slKrdN2M4Iynz5WTBnPcLcIygJfistEm+D4OiM='
WHERE
key_id = 'aa8ffd67e49d57e46ed014841e336ecfd009c8a5cdd3714ed4935bf950a45b4b'
AND (
token = '3epl6slKrdN2M4Iynz5WTBnPcLcIygJfistEm+D4OiM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)