UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6zAo1If7CC8yte+Zn6qVFZQxkASSZzLUg5EnIrSyUZU='
WHERE
key_id = '9a21c9ec6c60855ebbc02b9519c3430453dc00da24021240b61c3bafcf3fc287'
AND (
token = '6zAo1If7CC8yte+Zn6qVFZQxkASSZzLUg5EnIrSyUZU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)