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