UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7PJOTKvz1WZ6C9GSBSlt3xuVLoD+1//ak6rCzX93SBw='
WHERE
key_id = 'ef795092d25938e998a1e67647deddd59a774a7055294ef1e314c2a45195525d'
AND (
token = '7PJOTKvz1WZ6C9GSBSlt3xuVLoD+1//ak6rCzX93SBw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)