UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8OYT5SD4ZN4VgFP15PaZjh/8dt95o0jAXqlGk8kKXqU='
WHERE
key_id = '34d2a7b48f08a30c68944db4485825eafe58785b2d23173f19f21f8f4e1dc47e'
AND (
token = '8OYT5SD4ZN4VgFP15PaZjh/8dt95o0jAXqlGk8kKXqU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)