UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZKe/lF57jj7owIHx8np12Z/aUf6YGWfeF+ak947G8GE='
WHERE
key_id = '6ad1ce1cca537307a1739d7b98a17cfc5beeb099a054b5579c22099ea41bc5cb'
AND (
token = 'ZKe/lF57jj7owIHx8np12Z/aUf6YGWfeF+ak947G8GE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)