UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dg4G5xmaIyhAGgfaaNh1nesf6JGwyI9hPMBNN5V80+o='
WHERE
key_id = 'b82ae4cdbd283fde6fe94b306b444d4d76586668a1e46a8fd82fbde335aefbd3'
AND (
token = 'dg4G5xmaIyhAGgfaaNh1nesf6JGwyI9hPMBNN5V80+o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)