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