UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hfCIHh/oG5JrCESJk51e4HtJqv5IqxhoCZUuNP76Uqs='
WHERE
key_id = '14f135882c9b170ba746567a22dad7a4bcba5844f35e027473a41142fa36961e'
AND (
token = 'hfCIHh/oG5JrCESJk51e4HtJqv5IqxhoCZUuNP76Uqs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)