UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iZfbGj2twotrQJfy5cr9YkI9mfDVAy7Kxj3puZfu00U='
WHERE
key_id = 'd1d1c9aebab7b52e54092deafe1c235e030bf41962579cdef9fc8eae286e23d2'
AND (
token = 'iZfbGj2twotrQJfy5cr9YkI9mfDVAy7Kxj3puZfu00U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)