UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vzLSTiOX5RuZtxUbIar5ayjOjOHvc4DTZw9xSAeH/Ns='
WHERE
key_id = 'c6160fbf4dda4f537eae2d6d91d1af6384e9c60d1d5bfabcccd2185ffe80b178'
AND (
token = 'vzLSTiOX5RuZtxUbIar5ayjOjOHvc4DTZw9xSAeH/Ns='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)