UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HGdkVet9M1I+g6JWPnbGy4pmvvaBfMO4sxSu4OCSQVY='
WHERE
key_id = 'd7f4b0af0be3bca96bc8b3f5b15da0c8dd4eb7ddf5e42040b6d8f8627740ae4e'
AND (
token = 'HGdkVet9M1I+g6JWPnbGy4pmvvaBfMO4sxSu4OCSQVY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)