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