UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K7QAjsJaR1FjkO7WrLYKdNhiIQksQ0y1rpmsM1sxhKA='
WHERE
key_id = '846c5e957f86d186e4b31d08de03267c170b9ff31560d0f624e36eba9147ec15'
AND (
token = 'K7QAjsJaR1FjkO7WrLYKdNhiIQksQ0y1rpmsM1sxhKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)