UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2NSmgGs1QDGTcMtkoHp6/DDc4a2lu6ytmC6Yq7v71Yg='
WHERE
key_id = '410060e6384df6478d864b0df952a946f746148cc7e96c89520455397c47fa0d'
AND (
token = '2NSmgGs1QDGTcMtkoHp6/DDc4a2lu6ytmC6Yq7v71Yg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)