UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ihS/J8vGqEf8tkOf/iOMrIhJDg10E8Nave78xkOrBRo='
WHERE
key_id = '00e6b0544087a81c3a48de3dfe9d03117ec60b7ff101c99dd7bec67ede604fcd'
AND (
token = 'ihS/J8vGqEf8tkOf/iOMrIhJDg10E8Nave78xkOrBRo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)